package com.credithc.customers.base.po;

import lombok.Data;
import org.apache.ibatis.type.JdbcType;
import tk.mybatis.mapper.annotation.ColumnType;

import javax.persistence.Column;
import javax.persistence.Table;
import javax.persistence.Transient;
import java.math.BigDecimal;
import java.sql.Timestamp;

/**
 * @description: 客户购买产品记录表
 * @author: denghx
 * @date: 2018/11/28 10:33
 * @param: null
 * @return:
 */
@Data
@Table(name = "cust_product_info")
public class CustomerProductInfoPo extends CustomerBasePo {

    @Column(name = "user_source_id")
    private String userSourceId;

    @Column(name = "pre_customer_no")
    @ColumnType(jdbcType = JdbcType.VARCHAR)
    private String preCustomerNo;

    @Column(name = "customer_no")
    private String customerNo;

    @Column(name = "product_no")
    private String productNo;

    @Column(name = "product_source_system")
    private String productSourceSystem;

    @Column(name = "product_deadline")
    private String productDeadline;

    @Column(name = "product_amount")
    private BigDecimal productAmount;

    @Column(name = "product_start_time")
    private Timestamp productStartTime;

    @Column(name = "product_end_time")
    private Timestamp productEndTime;

    @Column(name = "product_status")
    private Integer productStatus;

    @Column(name = "update_time")
    private Timestamp updateTime;

    @Column(name = "system_sign")
    private String systemSign;

    @Column(name = "sub_system_sign")
    private String subSystemSign;

    @Column(name = "database_name")
    private String databaseName;

    @Column(name = "table_name")
    private String tableName;

    @Column(name = "table_key")
    private String tableKey;

    @Transient
    private String productType;

    @Transient
    private String customerName;

}
